// 学员相关的SQL语句
module.exports = {
  // 获取学员信息
  GET_STUDENT_PROFILE: `
    SELECT s.*, u.username, u.real_name, u.phone, u.email 
    FROM student_profiles s
    JOIN users u ON s.user_id = u.id
    WHERE s.user_id = ?
  `,

  // 创建学员信息
  CREATE_STUDENT_PROFILE: `
    INSERT INTO student_profiles (
      user_id, emergency_contact, emergency_phone, 
      dance_level, health_note
    ) VALUES (?, ?, ?, ?, ?)
  `,

  // 更新学员信息
  UPDATE_STUDENT_PROFILE: `
    UPDATE student_profiles 
    SET emergency_contact = ?, emergency_phone = ?, 
        dance_level = ?, health_note = ?
    WHERE user_id = ?
  `
}; 